Problem Note 47288: A SAS® Anti-Money Laundering query in the rc_combine macro does not account for Type 2 record changes
 |  |  |  |
The following query in the rc_combine macro does not account for Type 2 record changes in the fsk_risk_classifier table:
proc sql;
create table work.rc_active_tables as
select distinct source_table
from seg_kc.fsk_risk_classifier
where upcase(active_ind) = 'Y' and
upcase(risk_classifier_type_code) NE 'RC0'
order by source_table;
quit;
When a query is deactivated through the user interface, the rc_collapse macro might fail as a result of reading inactive records instead of active records.
The preceding query should be modified by adding and upcase(current_ind) = 'Y' and upcase(logical_delete_ind) = 'N' as follows:
proc sql;
create table work.rc_active_tables as
select distinct source_table
from seg_kc.fsk_risk_classifier
where upcase(active_ind) = 'Y' and
upcase(current_ind) = 'Y' and
upcase(logical_delete_ind) = 'N' and
upcase(risk_classifier_type_code) NE 'RC0'
order by source_table;
quit;
This change ensures that the proper results, Type 2 data, are provided to the rc_collapse macro.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for 64-Bit Itanium-based Systems | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows XP 64-bit Edition | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows 2000 Advanced Server | 2.2.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Datacenter Server | 2.2.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 2.2.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 2.2.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 2.2.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Windows Vista | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| HP-UX IPF | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Linux | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Solaris for x64 | 2.2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
A query in the rc_combine macro does not account for Type 2 record changes in the fsk_risk_classifier table. As a result, when a query is deactivated through the UI, the rc_collapse macro might fail due to reading inactive records instead of active records.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-09-11 15:38:41 |
| Date Created: | 2012-08-22 15:18:30 |